SELECT
  HIERARCHIZE
  ( DRILLDOWNMEMBER
    ( FILTER
      ( DRILLDOWNMEMBER
        ( FILTER
          ( DRILLDOWNMEMBER
            ( { [Date].[Calendar].Levels ( 0 ).Members }
            , [Date].[Calendar].[All Periods]
            )
          , ( ( ( not  ( ( [Date].[Calendar].CURRENTMEMBER
                       is
                         [Date].[Calendar].[All Periods]
                      )
                    AND
                      ( [Date].[Calendar].[All Periods].Children.Count <> 0 )
                    )
                AND
                  not  ( IsSibling
                      ( [Date].[Calendar].CURRENTMEMBER
                      , [Date].[Calendar].[All Periods]
                      )
                    AND
                      not
  ( [Date].[Calendar].CURRENTMEMBER
                         is
                           [Date].[Calendar].[All Periods]
                        )
                    )
                )
              AND
                not  IsAncestor
                  ( [Date].[Calendar].CURRENTMEMBER
                  , [Date].[Calendar].[All Periods]
                  )
              )
            AND
              ( IsAncestor
                ( [Date].[Calendar].[All Periods]
                , [Date].[Calendar].CURRENTMEMBER
                )
              OR
                ( [Date].[Calendar].CURRENTMEMBER
                 is
                   [Date].[Calendar].[All Periods]
                )
              )
            )          )        , [Date].[Calendar].[Calendar Year].&[2002]        )
      , ( ( ( not  ( ( [Date].[Calendar].CURRENTMEMBER                   is                   
  [Date].[Calendar].[Calendar Year].&[2002]                  )           
     AND    
              ( [Date].[Calendar].[Calendar Year].&[2002].Children.Count          
        <>  
                  0    
              ) 
               )            AND              not  ( IsSibling                  ( 
[Date].[Calendar].CURRENTMEMBER                  , [Date].[Calendar].[Calendar Year].&[2002]                  )                AND        
          not  ( [Date].[Calendar].CURRENTMEMBER                     is                       [Date].[Calendar].[Calendar Year].&[2002]       
             )                )            )          AND            not  IsAncestor              ( [Date].[Calendar].CURRENTMEMBER         
     , [Date].[Calendar].[Calendar Year].&[2002]              )          )        AND          ( IsAncestor         
   ( [Date].[Calendar].[Calendar Year].&[2002]            , [Date].[Calendar].CURRENTMEMBER            )          OR 
           ( [Date].[Calendar].CURRENTMEMBER             is               [Date].[Calendar].[Calendar Year].&[2002]          
  )          )        )      )    


, [Date].[Calendar].[Calendar Semester].&[2002]&[1]



    )  ) 
 DIMENSION PROPERTIES PARENT_UNIQUE_NAME , HIERARCHY_UNIQUE_NAME , CUSTOM_ROLLUP , UNARY_OPERATOR , KEY0 ON 0,
 HIERARCHIZE  ( DRILLUPMEMBER    ( FILTER      ( DRILLDOWNMEMBER        ( { [Product].[Product Categories].Levels ( 0 ).Members }   
     , [Product].[Product Categories].[All Products]        )      , ( ( ( not  ( ( [Product].[Product Categories].CURRENTMEMBER      
             is                     [Product].[Product Categories].[All Products]                  )                AND              
    ( [Product].[Product Categories].[All Products].Children.Count                  <>                    0                  )       
         )            AND              not  ( IsSibling                  ( [Product].[Product Categories].CURRENTMEMBER             
     , [Product].[Product Categories].[All Products]                  )                AND      
            not  ( [Product].[Product Categories].CURRENTMEMBER                     is          
             [Product].[Product Categories].[All Products]                    )                )            )    
      AND            not  IsAncestor              ( [Product].[Product Categories].CURRENTMEMBER      
        , [Product].[Product Categories].[All Products]              )          )        AND          ( IsAncestor        
    ( [Product].[Product Categories].[All Products]            , [Product].[Product Categories].CURRENTMEMBER            )    
      OR            ( [Product].[Product Categories].CURRENTMEMBER             is               [Product].[Product Categories].[All Products]   
         )          )        )      )    , [Product].[Product Categories].[Category].&[4]  
  )  )  DIMENSION PROPERTIES PARENT_UNIQUE_NAME , HIERARCHY_UNIQUE_NAME , CUSTOM_ROLLUP , UNARY_OPERATOR , KEY0 
ON 1FROM [Adventure Works]WHERE { [Measures].[Sales Amount] }
CELL PROPERTIES BACK_COLOR , CELL_ORDINAL , FORE_COLOR , FONT_NAME , FONT_SIZE , FONT_FLAGS , FORMAT_STRING , VALUE , FORMATTED_VALUE , UPDATEABLE
